0
  1. My Store
  2. Search

Search Results for "lipton tchae the vert orient 25 sachets 44g lot de 3"

Zexa Boîte à thé en Bois avec boîte de Rangement et diviseurs et Couvercle Transparent, Support pour Sachet à thé avec 9 Compartiments
Zexa Boîte à thé en Bois avec boîte de R...
View to See Price
View
Add to Cart
Whyyudan Stockage de thé utile Mini boîtes portatives de stockage de sucre de thé de bidon de thé de boîte de fer-blanc portatif (chat)
Whyyudan Stockage de thé utile Mini boît...
View to See Price
View
Add to Cart
Loveinwinter 9 Boîte À Thé Compartiment,Boîte d'emballage en Bois Solide De Boîte De Stockage De Boîte-Cadeau en Bois, Boîte De Stockage De Café
Loveinwinter 9 Boîte À Thé Compartiment,...
View to See Price
View
Add to Cart
CUHAWUDBA Passoire à Thé en à Feuilles Mobiles avec Cha?Nes et Plateaux D'éGouttement-Filtres pour Rooibos, Thé Vert et Oolong - 2 PièCes de ThéIèRe PCS et Une ThéIèRe de 2 PièCes pour Tasse
CUHAWUDBA Passoire à Thé en à Feuilles M...
View to See Price
View
Add to Cart
Boîte à Café Hermétique Pot à Café en Acier Inoxydable Coffret à Thé et Café Récipient pour Maintenir Café Frais
Boîte à Café Hermétique Pot à Café en Ac...
View to See Price
View
Add to Cart
Shumo Passoire à Thé en à Feuilles Mobiles avec Cha?Nes et Plateaux D'éGouttement-Filtres pour Rooibos, Thé Vert et Oolong - 2 PièCes de ThéIèRe PCS et Une ThéIèRe de 2 PièCes pour Tasse
Shumo Passoire à Thé en à Feuilles Mobil...
View to See Price
View
Add to Cart
Alter Éco - Thé Rooibos Au Caramel 40G - Lot De 4 - Livraison Rapide En France - Prix Par Lot
Alter Éco - Thé Rooibos Au Caramel 40G -...
View to See Price
View
Add to Cart
Alter Éco - Thé Rooibos Bio 40G - Lot De 4 - Livraison Rapide En France - Prix Par Lot
Alter Éco - Thé Rooibos Bio 40G - Lot De...
only €33,90
View
Add to Cart
Noblik Infuseur à thé en Acier Inoxydable avec chaîne et Plateaux d'égouttement - Filtres à thé pour Rooibos, thé Vert et thé Oolong - 2 pièces Maison et 2 pièces théière pour Tasse
Noblik Infuseur à thé en Acier Inoxydabl...
View to See Price
View
Add to Cart
Youliy Mini boîte à thé rétro en métal Motif paysage
Youliy Mini boîte à thé rétro en métal M...
only €4,09
View
Add to Cart
Vivaraise Couvre lit Stonewash Swami Rooibos 180 x 260 cm
Vivaraise Couvre lit Stonewash Swami Roo...
only €109,90
View
Add to Cart
Vivaraise Coussin Stonewashed Maia Chambray
Vivaraise Coussin Stonewashed Maia Chamb...
from €32,90
View
Add to Cart
Vivaraise Drap de Bain Bora Rooibos 90 x 150 cm
Vivaraise Drap de Bain Bora Rooibos 90 x...
only €32,90
View
Add to Cart
Vivaraise Couvre lit Stonewash Swami Rooibos 240 x 260 cm
Vivaraise Couvre lit Stonewash Swami Roo...
only €129,90
View
Add to Cart
Vivaraise Serviette invité Bora Rooibos 30 x 50 cm
Vivaraise Serviette invité Bora Rooibos ...
only €4,90
View
Add to Cart
Vivaraise Drap de Douche Bora Rooibos 70 x 130 cm
Vivaraise Drap de Douche Bora Rooibos 70...
only €22,90
View
Add to Cart
Vivaraise Plaid Stonewash Swami Rooibos 130 x 200 cm
Vivaraise Plaid Stonewash Swami Rooibos ...
only €64,90
View
Add to Cart
Jardin Bio Thé Vert Gingembre Citron Vert 30 g parent
Jardin Bio Thé Vert Gingembre Citron Ver...
only €2,78
View
Add to Cart

Browse Categories

Wait! We have a something for you...

Don't leave empty-handed! Simply enter your email below and we will send you a great discount on our products:

We hate spam as much as you do! Your details are never shared and you can unsubscribe at any time.

no thanks

Debug Overview

App Total Time DB Queries DB Query Total Time Amazon Requests
0.43950510025024 389 0.2225 0


No Amazon API Requests Made.


App Debug - Total Time 0.43950510025024 seconds

Number Time From Start Name Description
1 0.20996809005737 Initialise Initialise FSB Function
2 0.2113401889801 App Controller Start Start of the App controller (called before the controller of every page)
3 0.23582220077515 Start of getCategoryListByGroup Function Before first category groups query
4 0.23644113540649 After initial query Before first category groups query
5 0.23644113540649 Get Category List for Group Before the call to getCategoryList function
6 0.23644304275513 Start of GetCategoryList function Start of the function
7 0.23644518852234 Before getting categories Query to get specific category list
8 0.23706316947937 After getting categories Query to get specific category list
9 0.23706412315369 Before getting category custom Before call to function getCategoryCustom
10 0.25251412391663 After getting category custom After call to function getCategoryCustom
11 0.25251698493958 Before getting category custom Before call to function getCategoryCustom
12 0.26142501831055 After getting category custom After call to function getCategoryCustom
13 0.26142716407776 Before getting category custom Before call to function getCategoryCustom
14 0.26549816131592 After getting category custom After call to function getCategoryCustom
15 0.26549911499023 Before getting category custom Before call to function getCategoryCustom
16 0.26757097244263 After getting category custom After call to function getCategoryCustom
17 0.26757216453552 Before getting category custom Before call to function getCategoryCustom
18 0.26974320411682 After getting category custom After call to function getCategoryCustom
19 0.26974415779114 Before getting category custom Before call to function getCategoryCustom
20 0.27184700965881 After getting category custom After call to function getCategoryCustom
21 0.27184915542603 End of GetCategoryList function End of the function
22 0.27185297012329 Get Category List for Group Before the call to getCategoryList function
23 0.27185416221619 Start of GetCategoryList function Start of the function
24 0.2718551158905 Before getting categories Query to get specific category list
25 0.27210307121277 End of getCategoryListByGroup Function Before return()
26 0.2772650718689 App Controller End End of the App controller (called before the controller of every page)
27 0.39551615715027 App_after Controller Start Start of the App_after controller (called after the controller of every page)
28 0.39627003669739 Before Get Options Before the call to getOptions in the tpl class
29 0.43169498443604 After Get Options After the call to getOptions in the tpl class
30 0.43172717094421 App_after Controller End End of the App_after controller (called after the controller of every page)
31 0.43949699401855 Finalizing debug Before the debug is output to the page.
32 0.43950414657593 End of App This is the end of the app logging, final timestamp


Query Debug - 389 Database Queries. Total time 0.2225 seconds

Number Time (Seconds) Time (Milliseconds) Query
1 0.0014 0.0013720989227295 
SELECT parameter, value FROM parameters
2 0.0027 0.0026638507843018 
SELECT * FROM `bad_bots`
3 0.0003 0.00027108192443848 
SET time_zone = 'Europe/London'
4 0.0006 0.00064301490783691 
SELECT version FROM version ORDER BY `installed` DESC LIMIT 1
5 0.0006 0.00057792663574219 
INSERT INTO ga_users (`isbot`, `ips`) SELECT '1', 'a:1:{i:0;s:13:\"216.73.216.99\";}'
6 0.0005 0.00050711631774902 
INSERT INTO ga_sessions (`sessionlastseen`) SELECT '1757985307'
7 0.0010 0.0010089874267578 
SELECT * FROM autorun ORDER BY lastrun ASC
8 0.0003 0.00027585029602051 
SELECT * FROM version ORDER BY installed DESC LIMIT 1
9 0.0006 0.00058197975158691 
SELECT id FROM pages WHERE pagename = 'search' LIMIT 1
10 0.0003 0.00025582313537598 
SELECT * FROM pages WHERE id = 52
11 0.0012 0.0012431144714355 
SELECT * FROM template_options WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
12 0.0227 0.0226891040802 
SELECT * FROM template_text WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND language = 'en'
13 0.0003 0.00031304359436035 
SELECT * FROM pages WHERE pagename = 'search'
14 0.0006 0.00061488151550293 
SELECT * FROM categorygroups ORDER BY sortorder ASC
15 0.0006 0.00060892105102539 
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '1'  AND hidden = 0 ORDER BY sortorder ASC
16 0.0064 0.0063672065734863 
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 26
17 0.0007 0.00073504447937012 
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 26
18 0.0004 0.0004270076751709 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 26
19 0.0002 0.00022101402282715 
SELECT id FROM categories WHERE parent_id = '26'
20 0.0056 0.0056300163269043 
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (26)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1
21 0.0006 0.00055980682373047 
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (26)
				  AND p.disabled = 0
22 0.0007 0.00065898895263672 
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (26)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
23 0.0005 0.00054407119750977 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '26'
24 0.0002 0.0002291202545166 
SELECT * FROM categorygroups WHERE id = '1'
25 0.0034 0.0033750534057617 
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 27
26 0.0003 0.00027108192443848 
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 27
27 0.0002 0.00020599365234375 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 27
28 0.0002 0.00024604797363281 
SELECT id FROM categories WHERE parent_id = '27'
29 0.0038 0.0037579536437988 
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (27)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1
30 0.0003 0.0002598762512207 
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (27)
				  AND p.disabled = 0
31 0.0002 0.0002439022064209 
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (27)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
32 0.0003 0.00026512145996094 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '27'
33 0.0002 0.00023484230041504 
SELECT * FROM categorygroups WHERE id = '1'
34 0.0012 0.0012309551239014 
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 28
35 0.0003 0.00026202201843262 
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 28
36 0.0002 0.00021600723266602 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 28
37 0.0002 0.00023698806762695 
SELECT id FROM categories WHERE parent_id = '28'
38 0.0012 0.0012209415435791 
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (28)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1
39 0.0002 0.00021004676818848 
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (28)
				  AND p.disabled = 0
40 0.0002 0.00020599365234375 
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (28)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
41 0.0003 0.00025081634521484 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '28'
42 0.0002 0.00020503997802734 
SELECT * FROM categorygroups WHERE id = '1'
43 0.0003 0.00031805038452148 
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 29
44 0.0002 0.00021100044250488 
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 29
45 0.0002 0.00018095970153809 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 29
46 0.0002 0.00019598007202148 
SELECT id FROM categories WHERE parent_id = '29'
47 0.0003 0.00032591819763184 
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (29)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1
48 0.0002 0.0001981258392334 
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (29)
				  AND p.disabled = 0
49 0.0002 0.00020313262939453 
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (29)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
50 0.0002 0.00022196769714355 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '29'
51 0.0002 0.00019693374633789 
SELECT * FROM categorygroups WHERE id = '1'
52 0.0003 0.00030708312988281 
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 30
53 0.0002 0.00021100044250488 
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 30
54 0.0002 0.00017404556274414 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 30
55 0.0002 0.0002129077911377 
SELECT id FROM categories WHERE parent_id = '30'
56 0.0004 0.00038504600524902 
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (30)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1
57 0.0002 0.00019097328186035 
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (30)
				  AND p.disabled = 0
58 0.0002 0.00023102760314941 
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (30)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
59 0.0002 0.00022387504577637 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '30'
60 0.0002 0.00021100044250488 
SELECT * FROM categorygroups WHERE id = '1'
61 0.0003 0.00030899047851562 
SELECT COUNT(DISTINCT(c.product_id)) FROM products_categories c, products p WHERE c.product_id = p.id AND p.parent_id = 0 AND c.category_id = 31
62 0.0002 0.00020503997802734 
SELECT COUNT(*) FROM ebay_products p, products_categories pc WHERE p.id = pc.product_id AND prod_type = 'ebay' AND pc.category_id = 31
63 0.0002 0.00017499923706055 
SELECT COUNT(DISTINCT(bundle_id)) FROM bundle_categories WHERE category_id = 31
64 0.0002 0.00019097328186035 
SELECT id FROM categories WHERE parent_id = '31'
65 0.0003 0.0003349781036377 
SELECT COUNT(DISTINCT(p.id)) FROM products p, products_categories c
				WHERE p.id = c.product_id
				  AND c.category_id IN (31)
				  AND p.parent_id = 0
				  AND p.hidden = 0
				  AND p.enabled = 1
66 0.0002 0.00020194053649902 
SELECT COUNT(DISTINCT(p.id)) FROM bundles p, bundle_categories c
				WHERE p.id = c.bundle_id
				  AND c.category_id IN (31)
				  AND p.disabled = 0
67 0.0002 0.00023388862609863 
SELECT COUNT(DISTINCT(cp.id)) FROM custom_products cp, products_categories c
				WHERE cp.id = c.product_id
				  AND c.category_id IN (31)
				  AND c.prod_type = 'custom'
				  AND cp.hide = 0
68 0.0002 0.00022697448730469 
SELECT COUNT(DISTINCT(id)) FROM categories_autopopulate WHERE category_id = '31'
69 0.0002 0.00020408630371094 
SELECT * FROM categorygroups WHERE id = '1'
70 0.0002 0.0002439022064209 
SELECT * FROM categories WHERE parent_id = '0' AND categorygroup_id = '2'  AND hidden = 0 ORDER BY sortorder ASC
71 0.0016 0.0016458034515381 
SELECT * FROM manufacturers m WHERE m.display_sidebar = 1 AND m.merge_manufacturer_id = 0 ORDER BY linktitle ASC
72 0.0006 0.0005650520324707 
SELECT * FROM sideboxes WHERE (templateuid = 'fsb-fluid2018' OR templateuid = '') AND enabled = 1 ORDER BY sortorder ASC
73 0.0003 0.00031208992004395 
SELECT value FROM parameters WHERE parameter IN('EBAY_APP_ID' , 'EBAY_TRACKING_ID','EBAY_NETWORK_ID' , 'GOOGLE_SITE_KEY' , 'GOOGLE_SECRET_KEY' ,'GOOGLE_RECAPTCHA_TYPE','EBAY_AUTH_TOKEN','EBAY_LOCALE')ORDER BY parameter ASC
74 0.0004 0.00041508674621582 
SELECT * FROM sideboxes_pages WHERE sidebox_id = '26'
75 0.0010 0.0010201930999756 
SELECT value FROM template_options WHERE templateuid = 'fsb-fluid2018' AND optionuid = 'DISPLAY_CREDIT_ICON'
76 0.0005 0.00049400329589844 
SELECT * FROM pages WHERE core = 1 ORDER BY pagekey
77 0.0003 0.00027799606323242 
SELECT * FROM pages WHERE pagename = 'search'
78 0.0051 0.0051040649414062 
SELECT MAX(price) as maxprice, MIN(price) as minprice FROM products WHERE enabled = 1 AND hidden = 0 AND price <> 0
79 0.0016 0.001554012298584 
SELECT * FROM manufacturers WHERE display_filter = 1 AND merge_manufacturer_id = 0 ORDER BY name
80 0.0008 0.00081801414489746 
SELECT * FROM productattributenames n WHERE hidden = 0 AND metabrowse = 1 ORDER BY n.displayname ASC
81 0.0063 0.0062921047210693 
SELECT MAX(price) as maxprice, MIN(price) as minprice FROM products WHERE enabled = 1 AND hidden = 0 AND price <> 0
82 0.0017 0.0017449855804443 
SELECT * FROM manufacturers WHERE display_filter = 1 AND merge_manufacturer_id = 0 ORDER BY name
83 0.0005 0.00050997734069824 
SELECT * FROM productattributenames n WHERE hidden = 0 AND metabrowse = 1 AND sidebarfilter = 1 ORDER BY n.displayname ASC
84 0.0003 0.00034904479980469 
INSERT INTO searches (`keywords`, `timestamp`, `ip`) SELECT 'lipton tchae the vert orient 25 sachets 44g lot de 3', NOW(), '216.73.216.99'
85 0.0004 0.00043416023254395 
SELECT DISTINCT (p.id), salesrank, price, linktitle,
    MATCH (title)
    AGAINST ('+lipton +tchae +the +vert +orient +25 +sache} +44g +lot +de +3' IN BOOLEAN MODE) as searchrelevance, 'product' AS type
    FROM products p 
		WHERE MATCH (title) AGAINST ('+lipton +tchae +the +vert +orient +25 +sache} +44g +lot +de +3' IN BOOLEAN MODE)
		AND enabled = 1
		AND hidden = 0
		AND parent_id = 0
		
		AND 1 = 1 UNION SELECT DISTINCT(b.id), salesrank, price, title as `linktitle`, MATCH (title)
        AGAINST ('+lipton +tchae +the +vert +orient +25 +sache} +44g +lot +de +3'), 'bundle' AS type FROM bundles b
		WHERE MATCH (title) AGAINST ('+lipton +tchae +the +vert +orient +25 +sache} +44g +lot +de +3' IN BOOLEAN MODE)
		AND b.disabled = 0
		
		AND 1 = 1
86 0.0004 0.00038003921508789 
SELECT DISTINCT (p.id), salesrank, price, linktitle,
    MATCH (description, keyfeatures, title, descriptionsecondary)
    AGAINST ('+lipton +tchae +the +vert +orient +25 +sache} +44g +lot +de +3' IN BOOLEAN MODE) as searchrelevance, 'product' AS type
    FROM products p 
		WHERE MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+lipton +tchae +the +vert +orient +25 +sache} +44g +lot +de +3' IN BOOLEAN MODE)
		AND enabled = 1
		AND hidden = 0
		AND parent_id = 0
		
		AND 1 = 1 UNION SELECT DISTINCT(b.id), salesrank, price, title as `linktitle`, MATCH (description, keyfeatures, title, descriptionsecondary)
        AGAINST ('+lipton +tchae +the +vert +orient +25 +sache} +44g +lot +de +3'), 'bundle' AS type FROM bundles b
		WHERE MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+lipton +tchae +the +vert +orient +25 +sache} +44g +lot +de +3' IN BOOLEAN MODE)
		AND b.disabled = 0
		
		AND 1 = 1
87 0.0057 0.0056607723236084 
SELECT DISTINCT (p.id), salesrank, price, linktitle,
          'product' AS type
          FROM products p 
		WHERE ((description LIKE 'lipton') OR (keyfeatures LIKE 'lipton') OR (title LIKE 'lipton') OR (description LIKE 'tchae') OR (keyfeatures LIKE 'tchae') OR (title LIKE 'tchae') OR (description LIKE 'the') OR (keyfeatures LIKE 'the') OR (title LIKE 'the') OR (description LIKE 'vert') OR (keyfeatures LIKE 'vert') OR (title LIKE 'vert') OR (description LIKE 'orient') OR (keyfeatures LIKE 'orient') OR (title LIKE 'orient') OR (description LIKE '25') OR (keyfeatures LIKE '25') OR (title LIKE '25') OR (description LIKE 'sachets') OR (keyfeatures LIKE 'sachets') OR (title LIKE 'sachets') OR (description LIKE '44g') OR (keyfeatures LIKE '44g') OR (title LIKE '44g') OR (description LIKE 'lot') OR (keyfeatures LIKE 'lot') OR (title LIKE 'lot') OR (description LIKE 'de') OR (keyfeatures LIKE 'de') OR (title LIKE 'de') OR (description LIKE '3') OR (keyfeatures LIKE '3') OR (title LIKE '3'))

		AND enabled = 1
		AND hidden = 0
		AND parent_id = 0
		
		AND 1 = 1
88 0.0003 0.00030899047851562 
SELECT DISTINCT (p.id), price, linktitle,
          'ebayproduct' AS type
          FROM ebay_products p 
		WHERE ((description LIKE 'lipton') OR (title LIKE 'lipton') OR (description LIKE 'tchae') OR (title LIKE 'tchae') OR (description LIKE 'the') OR (title LIKE 'the') OR (description LIKE 'vert') OR (title LIKE 'vert') OR (description LIKE 'orient') OR (title LIKE 'orient') OR (description LIKE '25') OR (title LIKE '25') OR (description LIKE 'sachets') OR (title LIKE 'sachets') OR (description LIKE '44g') OR (title LIKE '44g') OR (description LIKE 'lot') OR (title LIKE 'lot') OR (description LIKE 'de') OR (title LIKE 'de') OR (description LIKE '3') OR (title LIKE '3'))
		AND hide = 0
89 0.0003 0.00029802322387695 
SELECT DISTINCT (p.id), price, linktitle,
          'customproduct' AS type
          FROM custom_products p 
		WHERE ((description LIKE 'lipton') OR (title LIKE 'lipton') OR (description LIKE 'tchae') OR (title LIKE 'tchae') OR (description LIKE 'the') OR (title LIKE 'the') OR (description LIKE 'vert') OR (title LIKE 'vert') OR (description LIKE 'orient') OR (title LIKE 'orient') OR (description LIKE '25') OR (title LIKE '25') OR (description LIKE 'sachets') OR (title LIKE 'sachets') OR (description LIKE '44g') OR (title LIKE '44g') OR (description LIKE 'lot') OR (title LIKE 'lot') OR (description LIKE 'de') OR (title LIKE 'de') OR (description LIKE '3') OR (title LIKE '3'))
		AND hide = 0
90 0.0004 0.00036120414733887 
SELECT DISTINCT (p.id), salesrank, price, linktitle,
    MATCH (description, keyfeatures, title, descriptionsecondary)
    AGAINST ('+lipton +tchae +the +vert +orient +25 +sache} +44g +lot +de +3' IN BOOLEAN MODE) as searchrelevance, 'product' AS type
    FROM products p 
		WHERE MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+lipton +tchae +the +vert +orient +25 +sache} +44g +lot +de +3' IN BOOLEAN MODE)
		AND enabled = 1
		AND hidden = 0
		AND parent_id = 0
		
		AND 1 = 1 UNION SELECT DISTINCT(b.id), salesrank, price, title as `linktitle`, MATCH (description, keyfeatures, title, descriptionsecondary)
        AGAINST ('+lipton +tchae +the +vert +orient +25 +sache} +44g +lot +de +3'), 'bundle' AS type FROM bundles b
		WHERE MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+lipton +tchae +the +vert +orient +25 +sache} +44g +lot +de +3' IN BOOLEAN MODE)
		AND b.disabled = 0
		
		AND 1 = 1
91 0.0081 0.0081040859222412 
SELECT DISTINCT (p.id), salesrank, price, linktitle,
          'product' AS type
          FROM products p 
		WHERE ((description LIKE '%lipton%') OR (keyfeatures LIKE '%lipton%') OR (title LIKE '%lipton%') OR (description LIKE '%tchae%') OR (keyfeatures LIKE '%tchae%') OR (title LIKE '%tchae%') OR (description LIKE '%the%') OR (keyfeatures LIKE '%the%') OR (title LIKE '%the%') OR (description LIKE '%vert%') OR (keyfeatures LIKE '%vert%') OR (title LIKE '%vert%') OR (description LIKE '%orient%') OR (keyfeatures LIKE '%orient%') OR (title LIKE '%orient%') OR (description LIKE '%25%') OR (keyfeatures LIKE '%25%') OR (title LIKE '%25%') OR (description LIKE '%sachets%') OR (keyfeatures LIKE '%sachets%') OR (title LIKE '%sachets%') OR (description LIKE '%44g%') OR (keyfeatures LIKE '%44g%') OR (title LIKE '%44g%') OR (description LIKE '%lot%') OR (keyfeatures LIKE '%lot%') OR (title LIKE '%lot%') OR (description LIKE '%de%') OR (keyfeatures LIKE '%de%') OR (title LIKE '%de%') OR (description LIKE '%3%') OR (keyfeatures LIKE '%3%') OR (title LIKE '%3%'))

		AND enabled = 1
		AND hidden = 0
		AND parent_id = 0
		
		AND 1 = 1
92 0.0003 0.00033903121948242 
SELECT DISTINCT (p.id), price, linktitle,
          'ebayproduct' AS type
          FROM ebay_products p 
		WHERE ((description LIKE '%lipton%') OR (title LIKE '%lipton%') OR (description LIKE '%tchae%') OR (title LIKE '%tchae%') OR (description LIKE '%the%') OR (title LIKE '%the%') OR (description LIKE '%vert%') OR (title LIKE '%vert%') OR (description LIKE '%orient%') OR (title LIKE '%orient%') OR (description LIKE '%25%') OR (title LIKE '%25%') OR (description LIKE '%sachets%') OR (title LIKE '%sachets%') OR (description LIKE '%44g%') OR (title LIKE '%44g%') OR (description LIKE '%lot%') OR (title LIKE '%lot%') OR (description LIKE '%de%') OR (title LIKE '%de%') OR (description LIKE '%3%') OR (title LIKE '%3%'))
		AND hide = 0
93 0.0003 0.00029492378234863 
SELECT DISTINCT (p.id), price, linktitle,
          'customproduct' AS type
          FROM custom_products p 
		WHERE ((description LIKE '%lipton%') OR (title LIKE '%lipton%') OR (description LIKE '%tchae%') OR (title LIKE '%tchae%') OR (description LIKE '%the%') OR (title LIKE '%the%') OR (description LIKE '%vert%') OR (title LIKE '%vert%') OR (description LIKE '%orient%') OR (title LIKE '%orient%') OR (description LIKE '%25%') OR (title LIKE '%25%') OR (description LIKE '%sachets%') OR (title LIKE '%sachets%') OR (description LIKE '%44g%') OR (title LIKE '%44g%') OR (description LIKE '%lot%') OR (title LIKE '%lot%') OR (description LIKE '%de%') OR (title LIKE '%de%') OR (description LIKE '%3%') OR (title LIKE '%3%'))
		AND hide = 0
94 0.0004 0.00040793418884277 
SELECT DISTINCT (p.id), salesrank, price, linktitle,
    MATCH (title)
    AGAINST ('+lipton +tchae +the +vert +orient +25 +sache} +44g +lot +de +3' IN BOOLEAN MODE) as searchrelevance, 'product' AS type
    FROM products p 
		WHERE MATCH (title) AGAINST ('+lipton +tchae +the +vert +orient +25 +sache} +44g +lot +de +3' IN BOOLEAN MODE)
		AND enabled = 1
		AND hidden = 0
		AND parent_id = 0
		
		AND 1 = 1 UNION SELECT DISTINCT(b.id), salesrank, price, title as `linktitle`, MATCH (title)
        AGAINST ('+lipton +tchae +the +vert +orient +25 +sache} +44g +lot +de +3'), 'bundle' AS type FROM bundles b
		WHERE MATCH (title) AGAINST ('+lipton +tchae +the +vert +orient +25 +sache} +44g +lot +de +3' IN BOOLEAN MODE)
		AND b.disabled = 0
		
		AND 1 = 1 ORDER BY salesrank ASC
95 0.0004 0.00039291381835938 
SELECT DISTINCT (p.id), salesrank, price, linktitle,
    MATCH (description, keyfeatures, title, descriptionsecondary)
    AGAINST ('+lipton +tchae +the +vert +orient +25 +sache} +44g +lot +de +3' IN BOOLEAN MODE) as searchrelevance, 'product' AS type
    FROM products p 
		WHERE MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+lipton +tchae +the +vert +orient +25 +sache} +44g +lot +de +3' IN BOOLEAN MODE)
		AND enabled = 1
		AND hidden = 0
		AND parent_id = 0
		
		AND 1 = 1 UNION SELECT DISTINCT(b.id), salesrank, price, title as `linktitle`, MATCH (description, keyfeatures, title, descriptionsecondary)
        AGAINST ('+lipton +tchae +the +vert +orient +25 +sache} +44g +lot +de +3'), 'bundle' AS type FROM bundles b
		WHERE MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+lipton +tchae +the +vert +orient +25 +sache} +44g +lot +de +3' IN BOOLEAN MODE)
		AND b.disabled = 0
		
		AND 1 = 1 ORDER BY salesrank ASC
96 0.0071 0.0071320533752441 
SELECT DISTINCT (p.id), salesrank, price, linktitle,
          'product' AS type
          FROM products p 
		WHERE ((description LIKE 'lipton') OR (keyfeatures LIKE 'lipton') OR (title LIKE 'lipton') OR (description LIKE 'tchae') OR (keyfeatures LIKE 'tchae') OR (title LIKE 'tchae') OR (description LIKE 'the') OR (keyfeatures LIKE 'the') OR (title LIKE 'the') OR (description LIKE 'vert') OR (keyfeatures LIKE 'vert') OR (title LIKE 'vert') OR (description LIKE 'orient') OR (keyfeatures LIKE 'orient') OR (title LIKE 'orient') OR (description LIKE '25') OR (keyfeatures LIKE '25') OR (title LIKE '25') OR (description LIKE 'sachets') OR (keyfeatures LIKE 'sachets') OR (title LIKE 'sachets') OR (description LIKE '44g') OR (keyfeatures LIKE '44g') OR (title LIKE '44g') OR (description LIKE 'lot') OR (keyfeatures LIKE 'lot') OR (title LIKE 'lot') OR (description LIKE 'de') OR (keyfeatures LIKE 'de') OR (title LIKE 'de') OR (description LIKE '3') OR (keyfeatures LIKE '3') OR (title LIKE '3'))

		AND enabled = 1
		AND hidden = 0
		AND parent_id = 0
		
		AND 1 = 1 ORDER BY salesrank ASC
97 0.0003 0.00027799606323242 
SELECT DISTINCT (p.id), price, linktitle,
          'ebayproduct' AS type
          FROM ebay_products p 
		WHERE ((description LIKE 'lipton') OR (title LIKE 'lipton') OR (description LIKE 'tchae') OR (title LIKE 'tchae') OR (description LIKE 'the') OR (title LIKE 'the') OR (description LIKE 'vert') OR (title LIKE 'vert') OR (description LIKE 'orient') OR (title LIKE 'orient') OR (description LIKE '25') OR (title LIKE '25') OR (description LIKE 'sachets') OR (title LIKE 'sachets') OR (description LIKE '44g') OR (title LIKE '44g') OR (description LIKE 'lot') OR (title LIKE 'lot') OR (description LIKE 'de') OR (title LIKE 'de') OR (description LIKE '3') OR (title LIKE '3'))
		AND hide = 0
98 0.0003 0.00025105476379395 
SELECT DISTINCT (p.id), price, linktitle,
          'customproduct' AS type
          FROM custom_products p 
		WHERE ((description LIKE 'lipton') OR (title LIKE 'lipton') OR (description LIKE 'tchae') OR (title LIKE 'tchae') OR (description LIKE 'the') OR (title LIKE 'the') OR (description LIKE 'vert') OR (title LIKE 'vert') OR (description LIKE 'orient') OR (title LIKE 'orient') OR (description LIKE '25') OR (title LIKE '25') OR (description LIKE 'sachets') OR (title LIKE 'sachets') OR (description LIKE '44g') OR (title LIKE '44g') OR (description LIKE 'lot') OR (title LIKE 'lot') OR (description LIKE 'de') OR (title LIKE 'de') OR (description LIKE '3') OR (title LIKE '3'))
		AND hide = 0
99 0.0003 0.00034809112548828 
SELECT DISTINCT (p.id), salesrank, price, linktitle,
    MATCH (description, keyfeatures, title, descriptionsecondary)
    AGAINST ('+lipton +tchae +the +vert +orient +25 +sache} +44g +lot +de +3' IN BOOLEAN MODE) as searchrelevance, 'product' AS type
    FROM products p 
		WHERE MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+lipton +tchae +the +vert +orient +25 +sache} +44g +lot +de +3' IN BOOLEAN MODE)
		AND enabled = 1
		AND hidden = 0
		AND parent_id = 0
		
		AND 1 = 1 UNION SELECT DISTINCT(b.id), salesrank, price, title as `linktitle`, MATCH (description, keyfeatures, title, descriptionsecondary)
        AGAINST ('+lipton +tchae +the +vert +orient +25 +sache} +44g +lot +de +3'), 'bundle' AS type FROM bundles b
		WHERE MATCH (description, keyfeatures, title, descriptionsecondary) AGAINST ('+lipton +tchae +the +vert +orient +25 +sache} +44g +lot +de +3' IN BOOLEAN MODE)
		AND b.disabled = 0
		
		AND 1 = 1 ORDER BY salesrank ASC
100 0.0062 0.0061831474304199 
SELECT DISTINCT (p.id), salesrank, price, linktitle,
          'product' AS type
          FROM products p 
		WHERE ((description LIKE '%lipton%') OR (keyfeatures LIKE '%lipton%') OR (title LIKE '%lipton%') OR (description LIKE '%tchae%') OR (keyfeatures LIKE '%tchae%') OR (title LIKE '%tchae%') OR (description LIKE '%the%') OR (keyfeatures LIKE '%the%') OR (title LIKE '%the%') OR (description LIKE '%vert%') OR (keyfeatures LIKE '%vert%') OR (title LIKE '%vert%') OR (description LIKE '%orient%') OR (keyfeatures LIKE '%orient%') OR (title LIKE '%orient%') OR (description LIKE '%25%') OR (keyfeatures LIKE '%25%') OR (title LIKE '%25%') OR (description LIKE '%sachets%') OR (keyfeatures LIKE '%sachets%') OR (title LIKE '%sachets%') OR (description LIKE '%44g%') OR (keyfeatures LIKE '%44g%') OR (title LIKE '%44g%') OR (description LIKE '%lot%') OR (keyfeatures LIKE '%lot%') OR (title LIKE '%lot%') OR (description LIKE '%de%') OR (keyfeatures LIKE '%de%') OR (title LIKE '%de%') OR (description LIKE '%3%') OR (keyfeatures LIKE '%3%') OR (title LIKE '%3%'))

		AND enabled = 1
		AND hidden = 0
		AND parent_id = 0
		
		AND 1 = 1 ORDER BY salesrank ASC
101 0.0003 0.00026893615722656 
SELECT DISTINCT (p.id), price, linktitle,
          'ebayproduct' AS type
          FROM ebay_products p 
		WHERE ((description LIKE '%lipton%') OR (title LIKE '%lipton%') OR (description LIKE '%tchae%') OR (title LIKE '%tchae%') OR (description LIKE '%the%') OR (title LIKE '%the%') OR (description LIKE '%vert%') OR (title LIKE '%vert%') OR (description LIKE '%orient%') OR (title LIKE '%orient%') OR (description LIKE '%25%') OR (title LIKE '%25%') OR (description LIKE '%sachets%') OR (title LIKE '%sachets%') OR (description LIKE '%44g%') OR (title LIKE '%44g%') OR (description LIKE '%lot%') OR (title LIKE '%lot%') OR (description LIKE '%de%') OR (title LIKE '%de%') OR (description LIKE '%3%') OR (title LIKE '%3%'))
		AND hide = 0
102 0.0002 0.00024294853210449 
SELECT DISTINCT (p.id), price, linktitle,
          'customproduct' AS type
          FROM custom_products p 
		WHERE ((description LIKE '%lipton%') OR (title LIKE '%lipton%') OR (description LIKE '%tchae%') OR (title LIKE '%tchae%') OR (description LIKE '%the%') OR (title LIKE '%the%') OR (description LIKE '%vert%') OR (title LIKE '%vert%') OR (description LIKE '%orient%') OR (title LIKE '%orient%') OR (description LIKE '%25%') OR (title LIKE '%25%') OR (description LIKE '%sachets%') OR (title LIKE '%sachets%') OR (description LIKE '%44g%') OR (title LIKE '%44g%') OR (description LIKE '%lot%') OR (title LIKE '%lot%') OR (description LIKE '%de%') OR (title LIKE '%de%') OR (description LIKE '%3%') OR (title LIKE '%3%'))
		AND hide = 0
103 0.0003 0.0002899169921875 
SELECT * FROM products WHERE id = '4137'
104 0.0006 0.0005800724029541 
SELECT * FROM productimages WHERE product_id = '4137' ORDER BY sortorder ASC
105 0.0003 0.00026798248291016 
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '4137' AND p.id = pi.product_id ORDER BY pi.sortorder
106 0.0006 0.00062108039855957 
SELECT * FROM product_image_select WHERE product_id = '4137'
107 0.0005 0.00049710273742676 
SELECT * FROM productcustomimages WHERE product_id = '4137'
108 0.0006 0.00056004524230957 
SELECT  o.product_id, MIN(o.price) as price, p.customprice
                FROM    products        p,
                        productoffers   o
                WHERE   p.id        = o.product_id
                  AND   p.parent_id = '4137'
                GROUP BY o.product_id
109 0.0007 0.00068187713623047 
SELECT  n.displayname, o.name
                FROM    productoptionnames  n,
                        productoptions      o,
                        products            p
                WHERE   n.originalname  = o.name
                  AND   o.product_id    = p.id
                  AND   p.parent_id     = '4137'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
110 0.0003 0.0002591609954834 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 4137
111 0.0006 0.00063085556030273 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4137' AND a.name = n.originalname
112 0.0002 0.00024580955505371 
SELECT * FROM productoffers WHERE product_id = '4137' AND merchantid = 'A1X6FK5RDHNB96'
113 0.0002 0.00024604797363281 
SELECT * FROM productoffers
                WHERE product_id = '4137' AND price > 0
                ORDER BY price ASC LIMIT 1
114 0.0002 0.00021600723266602 
SELECT * FROM productoffers
                WHERE product_id = 4137
                ORDER BY price ASC LIMIT 1
115 0.0002 0.00023913383483887 
SELECT value FROM productattributes
                WHERE product_id = '4137'
                AND name = 'ListPriceAmount'
116 0.0003 0.00026297569274902 
SELECT  o.product_id, MIN(o.price) as price, p.customprice
                FROM    products        p,
                        productoffers   o
                WHERE   p.id        = o.product_id
                  AND   p.parent_id = '4137'
                GROUP BY o.product_id
117 0.0004 0.00043702125549316 
SELECT  n.displayname, o.name
                FROM    productoptionnames  n,
                        productoptions      o,
                        products            p
                WHERE   n.originalname  = o.name
                  AND   o.product_id    = p.id
                  AND   p.parent_id     = '4137'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
118 0.0003 0.00026202201843262 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 4137
119 0.0004 0.00035309791564941 
SELECT value FROM productattributes WHERE product_id = '4137' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
120 0.0003 0.00027894973754883 
SELECT * FROM products WHERE parent_id = '4137'
121 0.0003 0.00033807754516602 
SELECT * FROM products WHERE id = '4145'
122 0.0004 0.00036787986755371 
SELECT * FROM productimages WHERE product_id = '4145' ORDER BY sortorder ASC
123 0.0005 0.0004580020904541 
SELECT * FROM product_image_select WHERE product_id = '4145'
124 0.0002 0.00020694732666016 
SELECT * FROM productcustomimages WHERE product_id = '4145'
125 0.0006 0.00062394142150879 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4145' AND a.name = n.originalname
126 0.0002 0.00023818016052246 
SELECT * FROM productoffers WHERE product_id = '4145' AND merchantid = 'A1X6FK5RDHNB96'
127 0.0003 0.00025486946105957 
SELECT * FROM productoffers
                WHERE product_id = '4145' AND price > 0
                ORDER BY price ASC LIMIT 1
128 0.0002 0.00022411346435547 
SELECT * FROM productoffers
                WHERE product_id = 4145
                ORDER BY price ASC LIMIT 1
129 0.0002 0.00024604797363281 
SELECT value FROM productattributes
                WHERE product_id = '4145'
                AND name = 'ListPriceAmount'
130 0.0003 0.00026106834411621 
SELECT value FROM productattributes WHERE product_id = '4145' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
131 0.0003 0.00027894973754883 
SELECT * FROM products WHERE id = '4151'
132 0.0003 0.00034809112548828 
SELECT * FROM productimages WHERE product_id = '4151' ORDER BY sortorder ASC
133 0.0005 0.00045299530029297 
SELECT * FROM product_image_select WHERE product_id = '4151'
134 0.0002 0.00019407272338867 
SELECT * FROM productcustomimages WHERE product_id = '4151'
135 0.0004 0.00041413307189941 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4151' AND a.name = n.originalname
136 0.0002 0.00023508071899414 
SELECT * FROM productoffers WHERE product_id = '4151' AND merchantid = 'A1X6FK5RDHNB96'
137 0.0002 0.00022292137145996 
SELECT * FROM productoffers
                WHERE product_id = '4151' AND price > 0
                ORDER BY price ASC LIMIT 1
138 0.0002 0.00023698806762695 
SELECT * FROM productoffers
                WHERE product_id = 4151
                ORDER BY price ASC LIMIT 1
139 0.0002 0.00023412704467773 
SELECT value FROM productattributes
                WHERE product_id = '4151'
                AND name = 'ListPriceAmount'
140 0.0003 0.0002601146697998 
SELECT value FROM productattributes WHERE product_id = '4151' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
141 0.0003 0.00026392936706543 
SELECT * FROM products WHERE id = '4158'
142 0.0004 0.0003511905670166 
SELECT * FROM productimages WHERE product_id = '4158' ORDER BY sortorder ASC
143 0.0005 0.00045299530029297 
SELECT * FROM product_image_select WHERE product_id = '4158'
144 0.0002 0.0001981258392334 
SELECT * FROM productcustomimages WHERE product_id = '4158'
145 0.0006 0.00055480003356934 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4158' AND a.name = n.originalname
146 0.0002 0.00024080276489258 
SELECT * FROM productoffers WHERE product_id = '4158' AND merchantid = 'A1X6FK5RDHNB96'
147 0.0002 0.00024819374084473 
SELECT * FROM productoffers
                WHERE product_id = '4158' AND price > 0
                ORDER BY price ASC LIMIT 1
148 0.0002 0.00022578239440918 
SELECT * FROM productoffers
                WHERE product_id = 4158
                ORDER BY price ASC LIMIT 1
149 0.0003 0.00026488304138184 
SELECT value FROM productattributes
                WHERE product_id = '4158'
                AND name = 'ListPriceAmount'
150 0.0003 0.00025010108947754 
SELECT value FROM productattributes WHERE product_id = '4158' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
151 0.0003 0.00026202201843262 
SELECT * FROM products WHERE id = '4175'
152 0.0003 0.00031208992004395 
SELECT * FROM productimages WHERE product_id = '4175' ORDER BY sortorder ASC
153 0.0004 0.00038790702819824 
SELECT * FROM product_image_select WHERE product_id = '4175'
154 0.0002 0.00019097328186035 
SELECT * FROM productcustomimages WHERE product_id = '4175'
155 0.0005 0.0005340576171875 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4175' AND a.name = n.originalname
156 0.0002 0.00023388862609863 
SELECT * FROM productoffers WHERE product_id = '4175' AND merchantid = 'A1X6FK5RDHNB96'
157 0.0002 0.00022196769714355 
SELECT * FROM productoffers
                WHERE product_id = '4175' AND price > 0
                ORDER BY price ASC LIMIT 1
158 0.0002 0.00024294853210449 
SELECT * FROM productoffers
                WHERE product_id = 4175
                ORDER BY price ASC LIMIT 1
159 0.0002 0.00023007392883301 
SELECT value FROM productattributes
                WHERE product_id = '4175'
                AND name = 'ListPriceAmount'
160 0.0002 0.000244140625 
SELECT value FROM productattributes WHERE product_id = '4175' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
161 0.0003 0.00025606155395508 
SELECT * FROM products WHERE id = '4180'
162 0.0003 0.00034785270690918 
SELECT * FROM productimages WHERE product_id = '4180' ORDER BY sortorder ASC
163 0.0005 0.00046801567077637 
SELECT * FROM product_image_select WHERE product_id = '4180'
164 0.0002 0.00018215179443359 
SELECT * FROM productcustomimages WHERE product_id = '4180'
165 0.0004 0.00043201446533203 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4180' AND a.name = n.originalname
166 0.0002 0.00023508071899414 
SELECT * FROM productoffers WHERE product_id = '4180' AND merchantid = 'A1X6FK5RDHNB96'
167 0.0002 0.00022315979003906 
SELECT * FROM productoffers
                WHERE product_id = '4180' AND price > 0
                ORDER BY price ASC LIMIT 1
168 0.0002 0.00020694732666016 
SELECT * FROM productoffers
                WHERE product_id = 4180
                ORDER BY price ASC LIMIT 1
169 0.0002 0.00023698806762695 
SELECT value FROM productattributes
                WHERE product_id = '4180'
                AND name = 'ListPriceAmount'
170 0.0002 0.00024890899658203 
SELECT value FROM productattributes WHERE product_id = '4180' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
171 0.0002 0.00023818016052246 
SELECT * FROM products WHERE id = '4201'
172 0.0003 0.00031399726867676 
SELECT * FROM productimages WHERE product_id = '4201' ORDER BY sortorder ASC
173 0.0002 0.00023794174194336 
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '4201' AND p.id = pi.product_id ORDER BY pi.sortorder
174 0.0004 0.00038409233093262 
SELECT * FROM product_image_select WHERE product_id = '4201'
175 0.0002 0.00018501281738281 
SELECT * FROM productcustomimages WHERE product_id = '4201'
176 0.0002 0.00023984909057617 
SELECT  o.product_id, MIN(o.price) as price, p.customprice
                FROM    products        p,
                        productoffers   o
                WHERE   p.id        = o.product_id
                  AND   p.parent_id = '4201'
                GROUP BY o.product_id
177 0.0003 0.00026202201843262 
SELECT  n.displayname, o.name
                FROM    productoptionnames  n,
                        productoptions      o,
                        products            p
                WHERE   n.originalname  = o.name
                  AND   o.product_id    = p.id
                  AND   p.parent_id     = '4201'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
178 0.0002 0.00021910667419434 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 4201
179 0.0004 0.00040221214294434 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4201' AND a.name = n.originalname
180 0.0002 0.00022101402282715 
SELECT * FROM productoffers WHERE product_id = '4201' AND merchantid = 'A1X6FK5RDHNB96'
181 0.0002 0.00023579597473145 
SELECT * FROM productoffers
                WHERE product_id = '4201' AND price > 0
                ORDER BY price ASC LIMIT 1
182 0.0003 0.00025081634521484 
SELECT * FROM productoffers
                WHERE product_id = 4201
                ORDER BY price ASC LIMIT 1
183 0.0002 0.00022697448730469 
SELECT value FROM productattributes
                WHERE product_id = '4201'
                AND name = 'ListPriceAmount'
184 0.0002 0.00023102760314941 
SELECT  o.product_id, MIN(o.price) as price, p.customprice
                FROM    products        p,
                        productoffers   o
                WHERE   p.id        = o.product_id
                  AND   p.parent_id = '4201'
                GROUP BY o.product_id
185 0.0003 0.00025391578674316 
SELECT  n.displayname, o.name
                FROM    productoptionnames  n,
                        productoptions      o,
                        products            p
                WHERE   n.originalname  = o.name
                  AND   o.product_id    = p.id
                  AND   p.parent_id     = '4201'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
186 0.0002 0.00022506713867188 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 4201
187 0.0002 0.00024795532226562 
SELECT value FROM productattributes WHERE product_id = '4201' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
188 0.0002 0.00022792816162109 
SELECT * FROM products WHERE parent_id = '4201'
189 0.0003 0.00028681755065918 
SELECT * FROM products WHERE id = '4202'
190 0.0003 0.00028610229492188 
SELECT * FROM productimages WHERE product_id = '4202' ORDER BY sortorder ASC
191 0.0004 0.00039792060852051 
SELECT * FROM product_image_select WHERE product_id = '4202'
192 0.0002 0.00018906593322754 
SELECT * FROM productcustomimages WHERE product_id = '4202'
193 0.0004 0.00039100646972656 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4202' AND a.name = n.originalname
194 0.0002 0.00023388862609863 
SELECT * FROM productoffers WHERE product_id = '4202' AND merchantid = 'A1X6FK5RDHNB96'
195 0.0002 0.00024604797363281 
SELECT * FROM productoffers
                WHERE product_id = '4202' AND price > 0
                ORDER BY price ASC LIMIT 1
196 0.0003 0.00029087066650391 
SELECT value FROM productattributes WHERE product_id = '4202' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
197 0.0003 0.00025701522827148 
SELECT * FROM products WHERE id = '4203'
198 0.0003 0.00030183792114258 
SELECT * FROM productimages WHERE product_id = '4203' ORDER BY sortorder ASC
199 0.0004 0.00040197372436523 
SELECT * FROM product_image_select WHERE product_id = '4203'
200 0.0002 0.00017786026000977 
SELECT * FROM productcustomimages WHERE product_id = '4203'
201 0.0004 0.00040292739868164 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4203' AND a.name = n.originalname
202 0.0002 0.00023102760314941 
SELECT * FROM productoffers WHERE product_id = '4203' AND merchantid = 'A1X6FK5RDHNB96'
203 0.0002 0.00021910667419434 
SELECT * FROM productoffers
                WHERE product_id = '4203' AND price > 0
                ORDER BY price ASC LIMIT 1
204 0.0002 0.00021004676818848 
SELECT * FROM productoffers
                WHERE product_id = 4203
                ORDER BY price ASC LIMIT 1
205 0.0002 0.0002281665802002 
SELECT value FROM productattributes
                WHERE product_id = '4203'
                AND name = 'ListPriceAmount'
206 0.0003 0.00027012825012207 
SELECT value FROM productattributes WHERE product_id = '4203' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
207 0.0003 0.00027608871459961 
SELECT * FROM products WHERE id = '4213'
208 0.0003 0.00032615661621094 
SELECT * FROM productimages WHERE product_id = '4213' ORDER BY sortorder ASC
209 0.0004 0.0004270076751709 
SELECT * FROM product_image_select WHERE product_id = '4213'
210 0.0002 0.00018596649169922 
SELECT * FROM productcustomimages WHERE product_id = '4213'
211 0.0006 0.0005650520324707 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4213' AND a.name = n.originalname
212 0.0002 0.00022292137145996 
SELECT * FROM productoffers WHERE product_id = '4213' AND merchantid = 'A1X6FK5RDHNB96'
213 0.0002 0.0002448558807373 
SELECT * FROM productoffers
                WHERE product_id = '4213' AND price > 0
                ORDER BY price ASC LIMIT 1
214 0.0003 0.00028705596923828 
SELECT value FROM productattributes WHERE product_id = '4213' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
215 0.0002 0.00024604797363281 
SELECT * FROM products WHERE id = '4246'
216 0.0003 0.00025606155395508 
SELECT * FROM productimages WHERE product_id = '4246' ORDER BY sortorder ASC
217 0.0004 0.00039005279541016 
SELECT * FROM product_image_select WHERE product_id = '4246'
218 0.0002 0.00018501281738281 
SELECT * FROM productcustomimages WHERE product_id = '4246'
219 0.0006 0.00057697296142578 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4246' AND a.name = n.originalname
220 0.0002 0.0002291202545166 
SELECT * FROM productoffers WHERE product_id = '4246' AND merchantid = 'A1X6FK5RDHNB96'
221 0.0002 0.00023794174194336 
SELECT * FROM productoffers
                WHERE product_id = '4246' AND price > 0
                ORDER BY price ASC LIMIT 1
222 0.0003 0.00032806396484375 
SELECT value FROM productattributes WHERE product_id = '4246' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
223 0.0002 0.00024104118347168 
SELECT * FROM products WHERE id = '4247'
224 0.0003 0.00025796890258789 
SELECT * FROM productimages WHERE product_id = '4247' ORDER BY sortorder ASC
225 0.0003 0.00029397010803223 
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '4247' AND p.id = pi.product_id ORDER BY pi.sortorder
226 0.0004 0.0003659725189209 
SELECT * FROM product_image_select WHERE product_id = '4247'
227 0.0002 0.00017595291137695 
SELECT * FROM productcustomimages WHERE product_id = '4247'
228 0.0003 0.00029897689819336 
SELECT  o.product_id, MIN(o.price) as price, p.customprice
                FROM    products        p,
                        productoffers   o
                WHERE   p.id        = o.product_id
                  AND   p.parent_id = '4247'
                GROUP BY o.product_id
229 0.0004 0.00040888786315918 
SELECT  n.displayname, o.name
                FROM    productoptionnames  n,
                        productoptions      o,
                        products            p
                WHERE   n.originalname  = o.name
                  AND   o.product_id    = p.id
                  AND   p.parent_id     = '4247'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
230 0.0003 0.00029683113098145 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 4247
231 0.0004 0.00040221214294434 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4247' AND a.name = n.originalname
232 0.0003 0.00026702880859375 
SELECT * FROM productoffers WHERE product_id = '4247' AND merchantid = 'A1X6FK5RDHNB96'
233 0.0002 0.00022578239440918 
SELECT * FROM productoffers
                WHERE product_id = '4247' AND price > 0
                ORDER BY price ASC LIMIT 1
234 0.0002 0.00021100044250488 
SELECT * FROM productoffers
                WHERE product_id = 4247
                ORDER BY price ASC LIMIT 1
235 0.0002 0.00022697448730469 
SELECT value FROM productattributes
                WHERE product_id = '4247'
                AND name = 'ListPriceAmount'
236 0.0003 0.00033807754516602 
SELECT  o.product_id, MIN(o.price) as price, p.customprice
                FROM    products        p,
                        productoffers   o
                WHERE   p.id        = o.product_id
                  AND   p.parent_id = '4247'
                GROUP BY o.product_id
237 0.0004 0.0003669261932373 
SELECT  n.displayname, o.name
                FROM    productoptionnames  n,
                        productoptions      o,
                        products            p
                WHERE   n.originalname  = o.name
                  AND   o.product_id    = p.id
                  AND   p.parent_id     = '4247'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
238 0.0003 0.00027990341186523 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 4247
239 0.0003 0.00026583671569824 
SELECT value FROM productattributes WHERE product_id = '4247' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
240 0.0004 0.00035381317138672 
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '4247'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Size'
                GROUP BY o.value
                ORDER BY o.value ASC
241 0.0003 0.00034594535827637 
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '4247'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'Color'
                GROUP BY o.value
                ORDER BY o.value ASC
242 0.0003 0.00025606155395508 
SELECT * FROM products WHERE id = '4257'
243 0.0003 0.00031495094299316 
SELECT * FROM productimages WHERE product_id = '4257' ORDER BY sortorder ASC
244 0.0004 0.0004119873046875 
SELECT * FROM product_image_select WHERE product_id = '4257'
245 0.0002 0.00019502639770508 
SELECT * FROM productcustomimages WHERE product_id = '4257'
246 0.0006 0.00057101249694824 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4257' AND a.name = n.originalname
247 0.0002 0.00023007392883301 
SELECT * FROM productoffers WHERE product_id = '4257' AND merchantid = 'A1X6FK5RDHNB96'
248 0.0003 0.00025105476379395 
SELECT * FROM productoffers
                WHERE product_id = '4257' AND price > 0
                ORDER BY price ASC LIMIT 1
249 0.0003 0.00032401084899902 
SELECT value FROM productattributes WHERE product_id = '4257' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
250 0.0002 0.00023794174194336 
SELECT * FROM products WHERE id = '4258'
251 0.0003 0.00028896331787109 
SELECT * FROM productimages WHERE product_id = '4258' ORDER BY sortorder ASC
252 0.0004 0.00037884712219238 
SELECT * FROM product_image_select WHERE product_id = '4258'
253 0.0002 0.00017690658569336 
SELECT * FROM productcustomimages WHERE product_id = '4258'
254 0.0006 0.0005800724029541 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4258' AND a.name = n.originalname
255 0.0002 0.00024604797363281 
SELECT * FROM productoffers WHERE product_id = '4258' AND merchantid = 'A1X6FK5RDHNB96'
256 0.0002 0.00024008750915527 
SELECT * FROM productoffers
                WHERE product_id = '4258' AND price > 0
                ORDER BY price ASC LIMIT 1
257 0.0003 0.00032401084899902 
SELECT value FROM productattributes WHERE product_id = '4258' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
258 0.0002 0.00023698806762695 
SELECT * FROM products WHERE id = '4259'
259 0.0003 0.00029611587524414 
SELECT * FROM productimages WHERE product_id = '4259' ORDER BY sortorder ASC
260 0.0004 0.00038695335388184 
SELECT * FROM product_image_select WHERE product_id = '4259'
261 0.0002 0.00018620491027832 
SELECT * FROM productcustomimages WHERE product_id = '4259'
262 0.0005 0.00054717063903809 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4259' AND a.name = n.originalname
263 0.0002 0.00024294853210449 
SELECT * FROM productoffers WHERE product_id = '4259' AND merchantid = 'A1X6FK5RDHNB96'
264 0.0002 0.00021600723266602 
SELECT * FROM productoffers
                WHERE product_id = '4259' AND price > 0
                ORDER BY price ASC LIMIT 1
265 0.0002 0.00021600723266602 
SELECT * FROM productoffers
                WHERE product_id = 4259
                ORDER BY price ASC LIMIT 1
266 0.0002 0.00022792816162109 
SELECT value FROM productattributes
                WHERE product_id = '4259'
                AND name = 'ListPriceAmount'
267 0.0003 0.00025391578674316 
SELECT value FROM productattributes WHERE product_id = '4259' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
268 0.0002 0.00024294853210449 
SELECT * FROM products WHERE id = '4260'
269 0.0003 0.0003058910369873 
SELECT * FROM productimages WHERE product_id = '4260' ORDER BY sortorder ASC
270 0.0004 0.0003969669342041 
SELECT * FROM product_image_select WHERE product_id = '4260'
271 0.0002 0.00019192695617676 
SELECT * FROM productcustomimages WHERE product_id = '4260'
272 0.0006 0.00056600570678711 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4260' AND a.name = n.originalname
273 0.0002 0.00023198127746582 
SELECT * FROM productoffers WHERE product_id = '4260' AND merchantid = 'A1X6FK5RDHNB96'
274 0.0003 0.00026106834411621 
SELECT * FROM productoffers
                WHERE product_id = '4260' AND price > 0
                ORDER BY price ASC LIMIT 1
275 0.0003 0.00034499168395996 
SELECT value FROM productattributes WHERE product_id = '4260' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
276 0.0003 0.00028204917907715 
SELECT * FROM products WHERE id = '4261'
277 0.0003 0.00030016899108887 
SELECT * FROM productimages WHERE product_id = '4261' ORDER BY sortorder ASC
278 0.0004 0.00037097930908203 
SELECT * FROM product_image_select WHERE product_id = '4261'
279 0.0002 0.0001828670501709 
SELECT * FROM productcustomimages WHERE product_id = '4261'
280 0.0006 0.00061511993408203 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4261' AND a.name = n.originalname
281 0.0002 0.00024104118347168 
SELECT * FROM productoffers WHERE product_id = '4261' AND merchantid = 'A1X6FK5RDHNB96'
282 0.0002 0.00023913383483887 
SELECT * FROM productoffers
                WHERE product_id = '4261' AND price > 0
                ORDER BY price ASC LIMIT 1
283 0.0003 0.00034880638122559 
SELECT value FROM productattributes WHERE product_id = '4261' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
284 0.0002 0.00023317337036133 
SELECT * FROM products WHERE id = '4474'
285 0.0003 0.00029706954956055 
SELECT * FROM productimages WHERE product_id = '4474' ORDER BY sortorder ASC
286 0.0003 0.00030279159545898 
SELECT pi.*, p.parent_id FROM productimages pi, products p WHERE p.parent_id = '4474' AND p.id = pi.product_id ORDER BY pi.sortorder
287 0.0004 0.00039291381835938 
SELECT * FROM product_image_select WHERE product_id = '4474'
288 0.0002 0.00022292137145996 
SELECT * FROM productcustomimages WHERE product_id = '4474'
289 0.0003 0.00025677680969238 
SELECT  o.product_id, MIN(o.price) as price, p.customprice
                FROM    products        p,
                        productoffers   o
                WHERE   p.id        = o.product_id
                  AND   p.parent_id = '4474'
                GROUP BY o.product_id
290 0.0003 0.00030112266540527 
SELECT  n.displayname, o.name
                FROM    productoptionnames  n,
                        productoptions      o,
                        products            p
                WHERE   n.originalname  = o.name
                  AND   o.product_id    = p.id
                  AND   p.parent_id     = '4474'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
291 0.0003 0.00025701522827148 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 4474
292 0.0004 0.00044012069702148 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4474' AND a.name = n.originalname
293 0.0002 0.00024509429931641 
SELECT * FROM productoffers WHERE product_id = '4474' AND merchantid = 'A1X6FK5RDHNB96'
294 0.0002 0.00023913383483887 
SELECT * FROM productoffers
                WHERE product_id = '4474' AND price > 0
                ORDER BY price ASC LIMIT 1
295 0.0002 0.00022006034851074 
SELECT * FROM productoffers
                WHERE product_id = 4474
                ORDER BY price ASC LIMIT 1
296 0.0002 0.00022602081298828 
SELECT value FROM productattributes
                WHERE product_id = '4474'
                AND name = 'ListPriceAmount'
297 0.0003 0.00026392936706543 
SELECT  o.product_id, MIN(o.price) as price, p.customprice
                FROM    products        p,
                        productoffers   o
                WHERE   p.id        = o.product_id
                  AND   p.parent_id = '4474'
                GROUP BY o.product_id
298 0.0003 0.00028204917907715 
SELECT  n.displayname, o.name
                FROM    productoptionnames  n,
                        productoptions      o,
                        products            p
                WHERE   n.originalname  = o.name
                  AND   o.product_id    = p.id
                  AND   p.parent_id     = '4474'
                GROUP BY n.displayname
                ORDER BY n.displayname DESC
299 0.0003 0.00027704238891602 
SELECT MAX(amountsaved) AS maxsaving, MIN(amountsaved) AS minsaving FROM productoffers o, products p WHERE o.product_id = p.id AND p.parent_id = 4474
300 0.0003 0.00026798248291016 
SELECT value FROM productattributes WHERE product_id = '4474' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
301 0.0004 0.00044393539428711 
SELECT  o.value
                FROM    products            p,
                        productoptions      o
                WHERE   p.parent_id     = '4474'
                  AND   p.id            = o.product_id
                  AND   o.name          = 'PackageQuantity'
                GROUP BY o.value
                ORDER BY o.value ASC
302 0.0003 0.00027894973754883 
SELECT * FROM products WHERE parent_id = '4474'
303 0.0003 0.00029110908508301 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4697' AND a.name = n.originalname
304 0.0003 0.00028109550476074 
SELECT * FROM productoffers WHERE product_id = '4697' AND merchantid = 'A1X6FK5RDHNB96'
305 0.0006 0.00058889389038086 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4137' ORDER BY timestamp DESC
306 0.0002 0.00023102760314941 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4145' ORDER BY timestamp DESC
307 0.0002 0.00021600723266602 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4151' ORDER BY timestamp DESC
308 0.0002 0.00020289421081543 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4158' ORDER BY timestamp DESC
309 0.0002 0.00019693374633789 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4175' ORDER BY timestamp DESC
310 0.0002 0.00018787384033203 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4180' ORDER BY timestamp DESC
311 0.0002 0.00019097328186035 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4201' ORDER BY timestamp DESC
312 0.0002 0.00018978118896484 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4202' ORDER BY timestamp DESC
313 0.0002 0.00018692016601562 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4203' ORDER BY timestamp DESC
314 0.0002 0.00018692016601562 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4213' ORDER BY timestamp DESC
315 0.0002 0.00022697448730469 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4246' ORDER BY timestamp DESC
316 0.0002 0.0001978874206543 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4247' ORDER BY timestamp DESC
317 0.0002 0.00018596649169922 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4257' ORDER BY timestamp DESC
318 0.0002 0.00018501281738281 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4258' ORDER BY timestamp DESC
319 0.0002 0.00018596649169922 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4259' ORDER BY timestamp DESC
320 0.0002 0.00019502639770508 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4260' ORDER BY timestamp DESC
321 0.0002 0.00018787384033203 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4261' ORDER BY timestamp DESC
322 0.0002 0.00020885467529297 
SELECT * FROM customerreviews WHERE approved = 1 AND productid = '4474' ORDER BY timestamp DESC
323 0.0006 0.00055503845214844 
SELECT * FROM template_info WHERE templateuid = 'fsb-fluid2018'
324 0.0005 0.00048303604125977 
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_user_data'
325 0.0002 0.00023484230041504 
SELECT ga_value FROM google_analytics_options WHERE `ga_key` = 'ga_tracking_status'
326 0.0119 0.011879920959473 
SELECT p.id,p.parent_id, o.price,p.asin FROM products p, productoffers o WHERE p.id = o.product_id AND p.parent_id = 0 AND hidden = 0 AND offers > 0 AND (SELECT COUNT(pi.id) FROM productimages pi WHERE pi.product_id = p.id) > 1 AND o.id IN (SELECT x.id FROM productoffers x WHERE x.product_id = p.id HAVING MIN(x.price)) ORDER BY p.title DESC LIMIT 6
327 0.0005 0.00051307678222656 
SELECT p.id,p.price,p.listingtype FROM ebay_products p WHERE hide = 0 AND (SELECT COUNT(pi.id) FROM ebay_prod_images pi WHERE pi.prodid = p.id) > 1 ORDER BY p.title DESC LIMIT 6
328 0.0002 0.00024819374084473 
SELECT p.id,p.price,p.currency FROM custom_products p WHERE hide = 0 AND orginalprice > 0 AND (SELECT COUNT(pi.id) FROM productcustomimages pi WHERE pi.product_id = p.id) > 1 ORDER BY p.title DESC LIMIT 6
329 0.0003 0.00029897689819336 
SELECT * FROM products WHERE id = 1626
330 0.0003 0.00025296211242676 
SELECT * FROM products WHERE id = 4041
331 0.0003 0.00028800964355469 
SELECT * FROM products WHERE id = 4312
332 0.0003 0.0002739429473877 
SELECT * FROM products WHERE id = 777
333 0.0003 0.00028896331787109 
SELECT * FROM products WHERE id = 3881
334 0.0003 0.00029706954956055 
SELECT * FROM products WHERE id = 4213
335 0.0003 0.00027894973754883 
SELECT * FROM products WHERE id = '1626'
336 0.0002 0.0002439022064209 
SELECT * FROM productimages WHERE product_id = '1626' ORDER BY sortorder ASC
337 0.0004 0.00043010711669922 
SELECT * FROM product_image_select WHERE product_id = '1626'
338 0.0002 0.00021600723266602 
SELECT * FROM productcustomimages WHERE product_id = '1626'
339 0.0005 0.00046896934509277 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '1626' AND a.name = n.originalname
340 0.0003 0.00027084350585938 
SELECT * FROM productoffers WHERE product_id = '1626' AND merchantid = 'A1X6FK5RDHNB96'
341 0.0003 0.00029802322387695 
SELECT * FROM productoffers
                WHERE product_id = '1626' AND price > 0
                ORDER BY price ASC LIMIT 1
342 0.0003 0.00029993057250977 
SELECT value FROM productattributes WHERE product_id = '1626' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
343 0.0003 0.0002901554107666 
SELECT * FROM products WHERE id = '4041'
344 0.0003 0.00025010108947754 
SELECT * FROM productimages WHERE product_id = '4041' ORDER BY sortorder ASC
345 0.0004 0.00041103363037109 
SELECT * FROM product_image_select WHERE product_id = '4041'
346 0.0002 0.00023508071899414 
SELECT * FROM productcustomimages WHERE product_id = '4041'
347 0.0006 0.00060105323791504 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4041' AND a.name = n.originalname
348 0.0003 0.00027108192443848 
SELECT * FROM productoffers WHERE product_id = '4041' AND merchantid = 'A1X6FK5RDHNB96'
349 0.0003 0.00028491020202637 
SELECT * FROM productoffers
                WHERE product_id = '4041' AND price > 0
                ORDER BY price ASC LIMIT 1
350 0.0003 0.00028204917907715 
SELECT value FROM productattributes WHERE product_id = '4041' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
351 0.0003 0.0002739429473877 
SELECT * FROM products WHERE id = '4312'
352 0.0003 0.00032186508178711 
SELECT * FROM productimages WHERE product_id = '4312' ORDER BY sortorder ASC
353 0.0004 0.00042605400085449 
SELECT * FROM product_image_select WHERE product_id = '4312'
354 0.0002 0.00021004676818848 
SELECT * FROM productcustomimages WHERE product_id = '4312'
355 0.0006 0.00057482719421387 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4312' AND a.name = n.originalname
356 0.0003 0.00025296211242676 
SELECT * FROM productoffers WHERE product_id = '4312' AND merchantid = 'A1X6FK5RDHNB96'
357 0.0003 0.00026607513427734 
SELECT * FROM productoffers
                WHERE product_id = '4312' AND price > 0
                ORDER BY price ASC LIMIT 1
358 0.0004 0.00036907196044922 
SELECT value FROM productattributes WHERE product_id = '4312' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
359 0.0003 0.00026798248291016 
SELECT * FROM products WHERE id = '777'
360 0.0003 0.00034904479980469 
SELECT * FROM productimages WHERE product_id = '777' ORDER BY sortorder ASC
361 0.0004 0.00038790702819824 
SELECT * FROM product_image_select WHERE product_id = '777'
362 0.0002 0.00021004676818848 
SELECT * FROM productcustomimages WHERE product_id = '777'
363 0.0006 0.00056219100952148 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '777' AND a.name = n.originalname
364 0.0002 0.00024294853210449 
SELECT * FROM productoffers WHERE product_id = '777' AND merchantid = 'A1X6FK5RDHNB96'
365 0.0003 0.00027203559875488 
SELECT * FROM productoffers
                WHERE product_id = '777' AND price > 0
                ORDER BY price ASC LIMIT 1
366 0.0003 0.00034093856811523 
SELECT value FROM productattributes WHERE product_id = '777' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
367 0.0003 0.00026798248291016 
SELECT * FROM products WHERE id = '3881'
368 0.0004 0.00036311149597168 
SELECT * FROM productimages WHERE product_id = '3881' ORDER BY sortorder ASC
369 0.0004 0.00044488906860352 
SELECT * FROM product_image_select WHERE product_id = '3881'
370 0.0002 0.00019001960754395 
SELECT * FROM productcustomimages WHERE product_id = '3881'
371 0.0006 0.00060796737670898 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '3881' AND a.name = n.originalname
372 0.0002 0.00023889541625977 
SELECT * FROM productoffers WHERE product_id = '3881' AND merchantid = 'A1X6FK5RDHNB96'
373 0.0003 0.00025320053100586 
SELECT * FROM productoffers
                WHERE product_id = '3881' AND price > 0
                ORDER BY price ASC LIMIT 1
374 0.0003 0.00033998489379883 
SELECT value FROM productattributes WHERE product_id = '3881' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
375 0.0003 0.00026392936706543 
SELECT * FROM products WHERE id = '4213'
376 0.0004 0.00036001205444336 
SELECT * FROM productimages WHERE product_id = '4213' ORDER BY sortorder ASC
377 0.0005 0.00048184394836426 
SELECT * FROM product_image_select WHERE product_id = '4213'
378 0.0002 0.00023818016052246 
SELECT * FROM productcustomimages WHERE product_id = '4213'
379 0.0006 0.00064396858215332 
SELECT a.name, n.displayname,a.value FROM productattributes a, productattributenames n WHERE product_id = '4213' AND a.name = n.originalname
380 0.0003 0.00025677680969238 
SELECT * FROM productoffers WHERE product_id = '4213' AND merchantid = 'A1X6FK5RDHNB96'
381 0.0003 0.00027680397033691 
SELECT * FROM productoffers
                WHERE product_id = '4213' AND price > 0
                ORDER BY price ASC LIMIT 1
382 0.0004 0.00035905838012695 
SELECT value FROM productattributes WHERE product_id = '4213' AND (name = 'ListPriceAmount' OR name = 'ListPriceFormattedPrice') ORDER BY name LIMIT 1
383 0.0008 0.00079107284545898 
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'header' ORDER BY sortorder ASC
384 0.0005 0.0004880428314209 
SELECT * FROM template_includes WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND area = 'footer' ORDER BY sortorder ASC
385 0.0015 0.001471996307373 
SELECT * FROM template_css WHERE deleted = 0 AND templateuid = 'fsb-fluid2018' AND skinuid = ''
386 0.0007 0.0006568431854248 
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
387 0.0004 0.00044584274291992 
SELECT * FROM template_images WHERE deleted = 0 AND templateuid = 'fsb-fluid2018'
388 0.0004 0.00041103363037109 
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'FB_DEFAULT_SHARE_IMAGE'
389 0.0004 0.00038886070251465 
SELECT * FROM template_images WHERE templateuid = 'fsb-fluid2018' AND imageuid = 'HEAD_LOGO'